package com.cloudkinto.dto.order.inbound;

import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.Data;

import java.math.BigDecimal;
import java.util.Date;

/**
 * @author long
 */
@Data
public class TransferInboundExportDto {

    @Excel(name = "Warehouse/仓库", fixedIndex = 0, width = 30)
    private String warehouseNameCode;

    @Excel(name = "Client/客户", fixedIndex = 1, width = 25)
    private String companyNameCode;

    @Excel(name = "Inbound Order No./入库单号", fixedIndex = 2, width = 30)
    private String sourceNo;

    @Excel(name = "Status/状态", fixedIndex = 3, width = 18)
    private String statusName;

    @Excel(name = "Creation time/创建时间", fixedIndex = 4, exportFormat = "yyyy-MM-dd HH:mm:ss", width = 30)
    private Date createTime;

    @Excel(name = "Receiving time/收货时间", fixedIndex = 5, exportFormat = "yyyy-MM-dd HH:mm:ss", width = 30)
    private Date receiptTime;

    @Excel(name = "Putaway time/上架时间", fixedIndex = 6, exportFormat = "yyyy-MM-dd HH:mm:ss", width = 30)
    private Date shelfTime;

    @Excel(name = "Estimated date of arrival/预计到达日期", fixedIndex = 7, exportFormat = "yyyy-MM-dd", width = 40)
    private Date expectedDate;

//    @Excel(name = "Total boxes/总箱数", fixedIndex = 8, width = 40)
//    private Integer boxTotalQty;

    @Excel(name = "Tracking No./Cargo No/跟踪号/货柜号", fixedIndex = 9, width = 40)
    private String trackingNumber;

    @Excel(name = "Remark/备注", fixedIndex = 10, width = 20)
    private String remark;

    @Excel(name = "Delivery Pallets/预报托盘数", fixedIndex = 11, width = 36)
    private Integer palletsTotalQty;

    @Excel(name = "Received Pallets/实收托盘数", fixedIndex = 12, width = 36)
    private Integer receiptPalletsQty;

    @Excel(name = "Box type/箱类型号", fixedIndex = 13, width = 30)
    private String boxTypeNumber;

    @Excel(name = "Custom box barcode/自定义箱条码", fixedIndex = 14, width = 40)
    private String customizeBarcode;

    @Excel(name = "Length from OMS/OMS长", fixedIndex = 15, width = 30)
    private BigDecimal length;

    @Excel(name = "Width from OMS/OMS宽", fixedIndex = 16, width = 30)
    private BigDecimal width;

    @Excel(name = "Height from OMS/OMS高", fixedIndex = 17, width = 30)
    private BigDecimal height;

    @Excel(name = "Unit/单位", fixedIndex = 18, width = 15)
    private String omsMeasureUnit;

    @Excel(name = "Weight from OMS/OMS重量", fixedIndex = 19, width = 30)
    private BigDecimal weight;

    @Excel(name = "Unit/单位", fixedIndex = 20, width = 15)
    private String omsWeightUnit;

    @Excel(name = "Length from WMS/WMS长", fixedIndex = 21, width = 30)
    private BigDecimal wmsLength;

    @Excel(name = "Width from WMS/WMS宽", fixedIndex = 22, width = 30)
    private BigDecimal wmsWidth;

    @Excel(name = "Height from WMS/WMS高", fixedIndex = 23, width = 30)
    private BigDecimal wmsHeight;

    @Excel(name = "Unit/单位", fixedIndex = 24, width = 15)
    private String wmsMeasureUnit;

    @Excel(name = "Weight from WMS/WMS重量", fixedIndex = 25, width = 30)
    private BigDecimal wmsWeight;

    @Excel(name = "Unit/单位", fixedIndex = 26, width = 15)
    private String wmsWeightUnit;

    @Excel(name = "Forecast Qty/预报箱数", fixedIndex = 27, width = 30)
    private Integer forecastBoxQty;

    @Excel(name = "Receipt boxes/已收货箱数", fixedIndex = 28, width = 30)
    private Integer receiptBoxQty;

    @Excel(name = "Putaway boxes/上架箱数", fixedIndex = 29, width = 30)
    private Integer shelfBoxQty;

    @Excel(name = "Un-putaway boxes/未上架箱数", fixedIndex = 30, width = 34)
    private Integer unShelfBoxQty;

    @Excel(name = "sku", fixedIndex = 31, width = 25)
    private String sku;

    @Excel(name = "sku总数量", fixedIndex = 32, width = 14)
    private Integer skuTotalQty;

    @Excel(name = "Qty per box /每箱数量", fixedIndex = 33, width = 30)
    private Integer perBoxQty;
}
